Tabela WaitingListXMLChangeLog

Definicja tabeli WaitingListXMLChangeLog

Name

WaitingListXMLChangeLog

Code

WaitingListXMLChangeLog

Comment

 


Lista kolumn tabeli WaitingListXMLChangeLog

Name

Code

WaitingListXMLChangeLogID

WaitingListXMLChangeLogID

ExportListID

ExportListID

WaitingListID

WaitingListID

CategoryID

CategoryID

ActualAvgTime

ActualAvgTime

ActualAvgTimeChanged

ActualAvgTimeChanged

PatientCount

PatientCount

ClosedOneMonthCumulative

ClosedOneMonthCumulative

ClosedOneMonthPerform

ClosedOneMonthPerform

ClosedSixMonthPerform

ClosedSixMonthPerform

FreeTermDate

FreeTermDate

FreeTermDateChanged

FreeTermDateChanged


Kolumna WaitingListXMLChangeLogID tabeli WaitingListXMLChangeLog

Definicja kolumny WaitingListXMLChangeLogID tabeli WaitingListXMLChangeLog

Name

WaitingListXMLChangeLogID

Code

WaitingListXMLChangeLogID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExportListID tabeli WaitingListXMLChangeLog

Definicja kolumny ExportListID tabeli WaitingListXMLChangeLog

Name

ExportListID

Code

ExportListID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna WaitingListID tabeli WaitingListXMLChangeLog

Definicja kolumny WaitingListID tabeli WaitingListXMLChangeLog

Name

WaitingListID

Code

WaitingListID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CategoryID tabeli WaitingListXMLChangeLog

Definicja kolumny CategoryID tabeli WaitingListXMLChangeLog

Name

CategoryID

Code

CategoryID

Data Type

NUMBER(5)

Mandatory

Yes

Comment

 


Kolumna ActualAvgTime tabeli WaitingListXMLChangeLog

Definicja kolumny ActualAvgTime tabeli WaitingListXMLChangeLog

Name

ActualAvgTime

Code

ActualAvgTime

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ActualAvgTimeChanged tabeli WaitingListXMLChangeLog

Definicja kolumny ActualAvgTimeChanged tabeli WaitingListXMLChangeLog

Name

ActualAvgTimeChanged

Code

ActualAvgTimeChanged

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna PatientCount tabeli WaitingListXMLChangeLog

Definicja kolumny PatientCount tabeli WaitingListXMLChangeLog

Name

PatientCount

Code

PatientCount

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ClosedOneMonthCumulative tabeli WaitingListXMLChangeLog

Definicja kolumny ClosedOneMonthCumulative tabeli WaitingListXMLChangeLog

Name

ClosedOneMonthCumulative

Code

ClosedOneMonthCumulative

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ClosedOneMonthPerform tabeli WaitingListXMLChangeLog

Definicja kolumny ClosedOneMonthPerform tabeli WaitingListXMLChangeLog

Name

ClosedOneMonthPerform

Code

ClosedOneMonthPerform

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna ClosedSixMonthPerform tabeli WaitingListXMLChangeLog

Definicja kolumny ClosedSixMonthPerform tabeli WaitingListXMLChangeLog

Name

ClosedSixMonthPerform

Code

ClosedSixMonthPerform

Data Type

NUMBER(5)

Mandatory

No

Comment

 


Kolumna FreeTermDate tabeli WaitingListXMLChangeLog

Definicja kolumny FreeTermDate tabeli WaitingListXMLChangeLog

Name

FreeTermDate

Code

FreeTermDate

Data Type

DATE

Mandatory

No

Comment

data pierwszego wolnego terminu na chwile uruchomienia raportu


Kolumna FreeTermDateChanged tabeli WaitingListXMLChangeLog

Definicja kolumny FreeTermDateChanged tabeli WaitingListXMLChangeLog

Name

FreeTermDateChanged

Code

FreeTermDateChanged

Data Type

DATE

Mandatory

No

Comment

data pierwszego wolnego terminu po edycji


Lista kluczy tabeli WaitingListXMLChangeLog

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli WaitingListXMLChangeLog

Definicja klucza Identifier_1 tabeli WaitingListXMLChangeLog

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment